<%@ page contentType="text/html; charset=utf-8" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<!-- TemplateBeginEditable name="doctitle" -->
<title>长沙电信管理系统</title>
<!-- TemplateEndEditable -->
<!-- TemplateBeginEditable name="head" -->
<!-- TemplateEndEditable -->
<script type="text/javascript" src="JS文件/daohanglan.js"></script>
<style type="text/css">
<!--
@import url("tpms.css");
-->
</style>
<script type="text/javascript" src="JS/daohanglan.js"></script>
<script type="text/javascript" >
function startTime()
{
var today=new Date()
var h=today.getHours()
var m=today.getMinutes()
var s=today.getSeconds()
// add a zero in front of numbers<10
m=checkTime(m)
s=checkTime(s)
document.getElementById('time').innerHTML="现在时间是："+h+":"+m+":"+s
t=setTimeout('startTime()',500)
}

function checkTime(i)
{
if (i<10) 
  {i="0" + i}
  return i
}
</script>

<%
 request.setCharacterEncoding("gb2312");
   //String vl = request.getParameter("button");
  //out.println(vl);
   Class.forName("com.mysql.jdbc.Driver");    
    String url="jdbc:mysql://localhost:3306/tpms?user=root&password=lizhk" ;
    Connection conn = DriverManager.getConnection(url);
    Statement stmt = conn.createStatement();
    //ResultSet rs = stmt.execute(sql);
    
    String username = request.getParameter("username");
    String password = request.getParameter("password");
    //out.println(username+" "+password);
    
    String sql="select * from user_info where username='"+username+"' and password='"+password+"'";
    ResultSet rs = stmt.executeQuery(sql);
    if(rs.next())
    {
       out.println("登录成功");
       
       }
    else
    out.println("");
    stmt.close();
    conn.close();
    //rs.close();   
 %>
</head>
  <body onload="startTime()">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr >
    <th align="center" scope="col">
    <table align="center" width="72%" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <th width="75%" height="85" align="left" scope="col"><img src="images/indexlogo.png" width="600" height="85" border="0" /></th>
        <th width="25%" scope="col"><table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
          <tr>
            <th align="left" nowrap="nowrap" class="登录信息" scope="col">当前用户：<span style="color: #F87B29">
            <%
            String str = request.getParameter("username");
            out.print(str);
            %>
            </span></th>
            <th nowrap="nowrap" class="登录信息" scope="col"><a href="用户登录.html" >注销</a>
            </th>
          </tr>
          <tr>
            <td colspan="2">&nbsp;</td>
          </tr>
          <tr>
            <td nowrap="nowrap" class="登录信息"><a href="密码修改.html">修改密码</a></td>
            <td nowrap="nowrap" class="登录信息"><a href="个人资料修改.html">修改个人资料</a></td>
          </tr>
        </table></th>
      </tr>
      <tr>
        <td height="5" colspan="2" bgcolor="#FA4500"></td>
      </tr>
      <tr>
        <td height="25" colspan="2" bgcolor="#FF4500">
       <ul id="nav">
	   
<li><a href="主界面.html">首页</a></li>
<li><a href="#l">用户管理</a>
<ul>
<li><a href="密码修改.html">密码修改</a></li>
<li><a href="个人资料修改.html">个人资料修改</a></li>

</ul>
</li>
<li><a href="#">产品维护</a>
<ul>
<li><a href="产品定义.html">产品定义</a></li>
<li><a href="维护主体和附属产品关系.html">维护主体和附属产品关系</a></li>
<li><a href="产品规则定义.html">产品规则定义</a></li>
<li><a href="产品定价.html">产品定价</a></li>
</ul>
</li>
<li><a href="#">资费管理</a>
<ul>
<li><a href="设置资费方案.html">设置资费方案</a></li>
<li><a href="资费规则维护.html">资费规则维护</a></li>
<li><a href="资费规则关系维护.html">资费规则关系维护</a></li>

</ul>
</li>
<li><a href="#">产品管理</a>
<ul>
<li><a href="产品包定义.html">产品包定义</a></li>
<li><a href="产品包定价.html">产品包定价</a></li>
<li><a href="建立客户性质与产品包.html">建立客户性质与产品包的关系</a></li>
</ul>
</li>
</ul>        </td>
      </tr>
      <tr>
        <td height="25" align="left" class="当前位置"><p>当前位置：首页&gt;&gt;产品管理&gt;&gt;产品包定义</p></td>
        <td id="time" align="right" class="当前位置">
<script type="text/javascript" >
function startTime()
{
var today=new Date()
var h=today.getHours()
var m=today.getMinutes()
var s=today.getSeconds()
// add a zero in front of numbers<10
m=checkTime(m)
s=checkTime(s)
document.getElementById('time').innerHTML="现在时间是："+h+":"+m+":"+s
t=setTimeout('startTime()',500)
}

function checkTime(i)
{
if (i<10) 
  {i="0" + i}
  return i
}
</script>
        </td>
        
      </tr>
     
      <tr>
        <td height="500" colspan="2" valign="top">
        <form id="form1" name="form1" method="post" action="propackage.jsp">
          <table width="100%" border="0" cellspacing="0" cellpadding="0">
            <tr>
              <th scope="col">
              <table class="下边框" width="100%"  border="1" cellspacing="0" cellpadding="1">
              <tr>
                <th width="100%" height="26" align="left" valign="middle" nowrap="nowrap" bgcolor="#639BCE" scope="col">
                <span class="列表标题" style="color: #FFF">归属产品</span>
                    <select name="saleType6" class="SELECT" >
                      <option value="ComMark" selected="selected">普通电话</option>
                      <option value="ComMark" >移动电话</option>
                    </select>
                    <input name="button" type="submit" id="button" value="查询" /></th>
              </tr>
            </table></th>
            </tr>
            <tr>
              <td>
              <table width="100%" border="0" cellspacing="0" cellpadding="0">
          <tr>
            <th height="20" align="left" scope="col"><img src="images/xiaotubiao.png" width="12" height="12" /><span class="列表标题1">查询结果</span></th>
          </tr>
          <tr>
            <td><table width="100%" border="0" cellspacing="0" cellpadding="0">
              <tr>
                <th scope="col">
                
                </th>
              </tr>
              <tr>
                <td><table width="100%" border="0" cellspacing="0" cellpadding="0">
                  <tr>
                    <th height="1" background="images/横虚点.png" scope="col"></th>
                  </tr>
                </table></td>
              </tr>
              <tr>
                <th height="250" valign="top" scope="col"><table width="100%" border="2" bordercolor="#FFFFFF" cellspacing="0" cellpadding="0">
                  <tr class="属性标题1">
                    <th height="20" class="属性标题1" scope="col">产品包标识</th>
                    <th height="20" class="属性标题1" scope="col">产品包名称</th>
                    <th height="20" class="属性标题1" scope="col">功能描述</th>
                    <th height="20" class="属性标题1" scope="col">归属产品</th>
                    <th height="20" class="属性标题1" scope="col">默认标志</th>
                    <th height="20" class="属性标题1" scope="col">生效日期</th>
                     <th height="20" class="属性标题1" scope="col">失效日期</th>
                      <th height="20" class="属性标题1" scope="col">备注</th>
                  </tr>
                  <tr>
                    <td height="20"><span class="tablecontent">344</span></td>
                    <td height="20"><span class="tablecontent">普通电话</span></td>
                    <td height="20" class="tablecontent">普通电话</td>
                    <td height="20"><span class="tablecontent">普通电话</span></td>
                    <td height="20"><span class="tablecontent">默认</span></td>
                    <td height="20" nowrap="nowrap" class="tablecontent">2009-07-01</td>
                  </tr>
                  <tr>
                    <td height="20"><span class="tablecontent">202</span></td>
                    <td height="20"><span class="tablecontent">普通电话-家家乐</span></td>
                    <td height="20"><span class="tablecontent">普通电话</span></td>
                    <td height="20"><span class="tablecontent">普通电话</span></td>
                    <td height="20"><span class="tablecontent">非默认</span></td>
                    <td height="20" class="tablecontent">2009-07-01</td>
                  </tr>
                  <tr>
                    <td height="20"><span class="tablecontent">562</span></td>
                    <td height="20"><span class="tablecontent">Test</span></td>
                    <td height="20"><span class="tablecontent">Test</span></td>
                    <td height="20"><span class="tablecontent">普通电话</span></td>
                    <td height="20"><span class="tablecontent">非默认</span></td>
                    <td height="20" class="tablecontent">2009-07-01</td>
                  </tr>
                  <tr>
                    <td height="20"><span class="tablecontent">541</span></td>
                    <td height="20"><span class="tablecontent">普通电话+XDSL</span></td>
                    <td height="20" nowrap="nowrap"><span class="tablecontent">普通电话+XDSL</span></td>
                    <td height="20" class="tablecontent">普通电话</td>
                    <td height="20" class="tablecontent">非默认</td>
                    <td height="20" class="tablecontent">2009-07-01</td>
                  </tr>
                  <tr>
                    <td height="20"><span class="tablecontent">542</span></td>
                    <td height="20" ><span class="列表标题1">普通电话加装XDSL</span></td>
                    <td height="20" nowrap="nowrap"><span class="列表标题1">普通电话加装XDSL</span></td>
                    <td height="20"><span class="tablecontent">普通电话</span></td>
                    <td height="20"><span class="tablecontent">非默认</span></td>
                    <td height="20" class="tablecontent">2009-07-01</td>
                  </tr>
                  <tr>
                    <td height="20"><span class="tablecontent">544</span></td>
                    <td height="20"><span class="列表标题1">激情八月</span></td>
                    <td height="20"><span class="tablecontent">普通电话+VPN</span></td>
                    <td height="20"><span class="tablecontent">普通电话</span></td>
                    <td height="20" class="tablecontent">非默认</td>
                    <td height="20" class="tablecontent">2009-07-01</td>
                  </tr>
                  <tr>
                    <td height="20"><span class="tablecontent">561</span></td>
                    <td height="20"><span class="列表标题1">激情七月</span></td>
                    <td height="20"><span class="tablecontent">激情七月</span></td>
                    <td height="20"><span class="tablecontent">普通电话</span></td>
                    <td height="20"><span class="tablecontent">非默认</span></td>
                    <td height="20" class="tablecontent">2009-07-01</td>
                  </tr>
                </table></th>
              </tr>
              <tr>
                <td height="30" align="right" valign="middle">
                            <span id="文本表单">共
                              <input type="text" size="5"/>页&nbsp;
                              第<input type="text" size="5"/>页</span>&nbsp;
                            <input type="button" value="首页"  />
                            <input type="button" value="上一页" />
                            <input type="button" value="下一页"  />
                            <input type="button" value="最后" />
   
                          </td>
              </tr>
              <tr>
                <td height="30" valign="middle"><table width="100%" border="0" cellspacing="0" cellpadding="0">
                  <tr>
                    <th height="1" background="images/横虚点.png" scope="col"></th>
                  </tr>
                </table>
                </td>
              </tr>
              <tr>
                <td><table width="100%" border="0" cellspacing="0" cellpadding="0">
                  <tr>
                     <td height="40" align="left" ><img src="images/xiaotubiao.png" width="12" height="12" /><span class="列表标题"><a href="#">产品包定义</a> | <a href="#">产品包适用区域</a></span></td>
                    </tr>
                  <tr>
                    <td>  
                  <span class="列表标题">产品包标识</span>
                    <input name="" type="text" value="541" size="10" />
                   
                    </td>
                    <td height="30">
                  <span class="列表标题">产品包名称<span class="星号">*</span></span>
                    <input name="" type="text" value="普通电话+XDSL" size="20" />
                    </td>
                    <td>
                  <span class="列表标题">归属产品<span class="星号">*</span></span>
                    <select name="saleType5" class="SELECT" >
                          <option value="ComMark" selected="selected">普通电话</option>
                          <option value="ComMark" >宽带业务</option>
                          </select>
                  </td>
                  </tr>
                  <tr>
                    <td height="30" colspan="3">
                 <span class="列表标题">功能描述<span class="星号">*</span></span>
                    <input name="" type="text" value="普通电话+XDSL" size="50" />
                    </td>
                    </tr>
                  <tr>
                    <td height="30">
                 <span class="列表标题">生效日期<span class="星号">*</span></span>
                    <input name="" type="text" value="180" size="10" />
                   </td>
                    <td>
                   <span class="列表标题">失效日期<span class="星号">*</span></span>
                    <input name="" type="text" value="2010-07-28" size="20" />
                  </td>
                    <td>
                  <span class="列表标题">排序号<span class="星号">*</span></span>
                    <input name="" type="text" value="38" size="10" />
                  </td>
                  </tr>
                  <tr>
                    <td>
                      <div align="left" ><span class="列表标题">标准编码</span>
                        <input name="" type="text" value="ADD" size="10" />
                        </div>
                   </td>
                    <td>
                      <div align="left" ><span class="列表标题">标准名称</span>
                        <input name="" type="text" value="普通电话+XDSL" size="20" />
                        </div>
                    </td>
                    <td>
                      <div align="left" ><span class="列表标题">备注</span>
                        <input name="" type="text" value="38" size="10" />
                        </div>
                   </td>
                  </tr>
                  </table></td>
              </tr>
              <tr>
                <td align="right">
                    <input type="submit" name="b1" id="b1" value="新增" />
                    <input type="submit" name="b2" id="b2" value="修改" />
                    <input type="submit" name="b3" id="b3" value="删除" />
                    <input type="button" name="b5" id="b5" value="退出" onclick="document.location.href='主界面.html'"/>
              </td>
              </tr>
            </table></td>
          </tr>
        </table>
              </td>
            </tr>
          </table>
        
        </form></td>
      </tr>
      <tr>
        <td height="30" colspan="2" align="center" valign="bottom" bgcolor="#639BCE"><p class="页脚">版权所有：湖南省电信有限公司长沙市分公司管理系统 经营许可证号：湘ICP证010001</p>
          <p class="页脚">Copyright @2009-2019, China Telecom, All right reserved</p></td>
      </tr>
    </table></th>
  </tr>
</table>
<p>&nbsp;</p>
</body>
</html>
